You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON product.id=asset.parent WHERE' at line 1<br>SELECT product.id,product.nr,product.name,product.size,product.volume,product.eancode,product.icon,product.modified FROM product ON product.id=asset.parent WHERE